package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.LmbConsumableInventDetail;

public interface LmbConsumableInventDetailDAO extends CrudRepository<LmbConsumableInventDetail, String> {
	@Query("select max(c.cidId) from LmbConsumableInventDetail c where c.cidId like ?1%")
    public String findMaxID(String a);
	
	@Query("select s from LmbConsumableInventDetail s where s.cidCiId = ?1 order by s.cidId asc")
	public List<LmbConsumableInventDetail> findinventDet(String id);
}
